﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ETL.Entity;

namespace ETL.DataAccess
{
    public class ProjectOverheadRepository
    {
        public IEnumerable<project_overheads> GetProjectOverheads()
        {
            var db = new ETLDataEntities();
            
            var overheads = from o in db.project_overheads
                            where o.o_active == true && o.o_overhead == true
                            orderby o.o_order
                            select o;

            if (overheads.Any())
                return overheads;
            else
            {
                return null;
            }
        }
    }
}
